
Create PROC [dbo].[sp_KhoHang_Update](
	@ID						INT,
	@MaSanPham				Int,
	@SoLuong				INT
)
AS
BEGIN
	DECLARE @Ngay_cap_nhat_cuoi datetime
	SET @Ngay_cap_nhat_cuoi = getdate()
UPDATE KhoHang
		SET
					
					ma_san_pham = @MaSanPham,
					soluong = @SoLuong,
					ngay_cap_nhat_cuoi = @Ngay_cap_nhat_cuoi
	WHERE 				
					id = @ID

END